Importing CSV file

When importing a CSV file, I cannot seem to set the Object Level - all objects come in at 'Object Level' = '1' even though the CSV file has the level set to other values.  This then takes time (which is non-value added) to go through and indent all of the objects to their correct level.

How does one import the data so that it comes in at the desired level?

Same question for importing RTF files as same issue exists here.  Is the issue with RTF files remedied by importing from MS Word file instead of RTF?


Mike.P.Adams - Mon May 11 09:29:26 EDT 2015

Re: Importing CSV file
Chris Annal - Mon May 11 10:40:13 EDT 2015

I'm attaching a Word document that describes how to import an Excel spreadsheet and set the Object Levels, using a DXL script that is embedded at the end of the document. You may want to try this out in a Sandbox project first to see if it meets your needs.


Attachments

doors_tech_tip_-_importing_spreadsheets.docx

Re: Importing CSV file
ChrisHardy68 - Mon May 11 18:47:46 EDT 2015

Hi

In addition to Chris Annal's response, there is also a sample script provided with DOORS that can structure objects based on Section number

To find it :

Open a module, Select  Tools - DXl library, Expand "Some example programs which illustrate various DXL features" and find

"Example to move objects in to structure suggested by section numbers"

Or find the script under:

<DOORS Client Install location>\lib\dxl\example\levels.dxl

The DXL may need tweaking but is another option for post import "clean up" of csv files

 

Re: Importing CSV file
Mike.P.Adams - Tue May 12 08:45:19 EDT 2015

Chris Annal - Mon May 11 10:40:13 EDT 2015

I'm attaching a Word document that describes how to import an Excel spreadsheet and set the Object Levels, using a DXL script that is embedded at the end of the document. You may want to try this out in a Sandbox project first to see if it meets your needs.

Chris,

Thanks - this provides what I need!